﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsCaja" targetNamespace="http://tempuri.org/dsCaja.xsd" xmlns:mstns="http://tempuri.org/dsCaja.xsd" xmlns="http://tempuri.org/dsCaja.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString2 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString2" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString" Provider="Oracle.DataAccess.Client" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAJ_CAJASTableAdapter" GeneratorDataComponentClassName="CAJ_CAJASTableAdapter" Name="CAJ_CAJAS" UserDataComponentName="CAJ_CAJASTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_CAJAS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CAJ_CAJAS" WHERE (("IDCAJA" = :Original_IDCAJA) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_IDSUCURSAL = 1 AND "IDSUCURSAL" IS NULL) OR ("IDSUCURSAL" = :Original_IDSUCURSAL)) AND ((:IsNull_FECHAULTCUADRE = 1 AND "FECHAULTCUADRE" IS NULL) OR ("FECHAULTCUADRE" = :Original_FECHAULTCUADRE)) AND ((:IsNull_SALDO = 1 AND "SALDO" IS NULL) OR ("SALDO" = :Original_SALDO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDSUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDSUCURSAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDSUCURSAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSUCURSAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAULTCUADRE" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAULTCUADRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAULTCUADRE" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAULTCUADRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALDO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CAJ_CAJAS" ("IDCAJA", "DESCRIPCION", "IDSUCURSAL", "FECHAULTCUADRE", "SALDO") VALUES (:IDCAJA, :DESCRIPCION, :IDSUCURSAL, :FECHAULTCUADRE, :SALDO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDSUCURSAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAULTCUADRE" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAULTCUADRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDCAJA, DESCRIPCION, IDSUCURSAL, FECHAULTCUADRE, SALDO FROM SAMUEL.CAJ_CAJAS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CAJ_CAJAS" SET "IDCAJA" = :IDCAJA, "DESCRIPCION" = :DESCRIPCION, "IDSUCURSAL" = :IDSUCURSAL, "FECHAULTCUADRE" = :FECHAULTCUADRE, "SALDO" = :SALDO WHERE (("IDCAJA" = :Original_IDCAJA) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_IDSUCURSAL = 1 AND "IDSUCURSAL" IS NULL) OR ("IDSUCURSAL" = :Original_IDSUCURSAL)) AND ((:IsNull_FECHAULTCUADRE = 1 AND "FECHAULTCUADRE" IS NULL) OR ("FECHAULTCUADRE" = :Original_FECHAULTCUADRE)) AND ((:IsNull_SALDO = 1 AND "SALDO" IS NULL) OR ("SALDO" = :Original_SALDO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDSUCURSAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAULTCUADRE" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAULTCUADRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDSUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDSUCURSAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDSUCURSAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSUCURSAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAULTCUADRE" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAULTCUADRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAULTCUADRE" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAULTCUADRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALDO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCAJA" DataSetColumn="IDCAJA" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="IDSUCURSAL" DataSetColumn="IDSUCURSAL" />
              <Mapping SourceColumn="FECHAULTCUADRE" DataSetColumn="FECHAULTCUADRE" />
              <Mapping SourceColumn="SALDO" DataSetColumn="SALDO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_CAJAS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdCaja" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdCaja" GeneratorSourceName="FillByIdCaja" GetMethodModifier="Public" GetMethodName="GetDataByIdCaja" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdCaja" UserSourceName="FillByIdCaja">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDCAJA, DESCRIPCION, IDSUCURSAL, FECHAULTCUADRE, SALDO
FROM            CAJ_CAJAS
WHERE        (IDCAJA = :PIDCAJA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDCAJA" ColumnName="IDCAJA" DataSourceName="SAMUEL.CAJ_CAJAS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAJ_GASTOTableAdapter" GeneratorDataComponentClassName="CAJ_GASTOTableAdapter" Name="CAJ_GASTO" UserDataComponentName="CAJ_GASTOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_GASTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CAJ_GASTO" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_IDTIPOGASTO = 1 AND "IDTIPOGASTO" IS NULL) OR ("IDTIPOGASTO" = :Original_IDTIPOGASTO)) AND ((:IsNull_VALOR = 1 AND "VALOR" IS NULL) OR ("VALOR" = :Original_VALOR)) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_FECHA = 1 AND "FECHA" IS NULL) OR ("FECHA" = :Original_FECHA)) AND ((:IsNull_IDCAJA = 1 AND "IDCAJA" IS NULL) OR ("IDCAJA" = :Original_IDCAJA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOGASTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOGASTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOGASTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOGASTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALOR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCAJA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CAJ_GASTO" ("IDDOCUMENTO", "NUMERO", "IDTIPOGASTO", "VALOR", "DESCRIPCION", "FECHA", "IDCAJA") VALUES (:IDDOCUMENTO, :NUMERO, :IDTIPOGASTO, :VALOR, :DESCRIPCION, :FECHA, :IDCAJA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOGASTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOGASTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDOCUMENTO, NUMERO, IDTIPOGASTO, VALOR, DESCRIPCION, FECHA, IDCAJA FROM SAMUEL.CAJ_GASTO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CAJ_GASTO" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "IDTIPOGASTO" = :IDTIPOGASTO, "VALOR" = :VALOR, "DESCRIPCION" = :DESCRIPCION, "FECHA" = :FECHA, "IDCAJA" = :IDCAJA WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_IDTIPOGASTO = 1 AND "IDTIPOGASTO" IS NULL) OR ("IDTIPOGASTO" = :Original_IDTIPOGASTO)) AND ((:IsNull_VALOR = 1 AND "VALOR" IS NULL) OR ("VALOR" = :Original_VALOR)) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_FECHA = 1 AND "FECHA" IS NULL) OR ("FECHA" = :Original_FECHA)) AND ((:IsNull_IDCAJA = 1 AND "IDCAJA" IS NULL) OR ("IDCAJA" = :Original_IDCAJA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOGASTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOGASTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOGASTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOGASTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOGASTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOGASTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALOR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCAJA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="IDTIPOGASTO" DataSetColumn="IDTIPOGASTO" />
              <Mapping SourceColumn="VALOR" DataSetColumn="VALOR" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="FECHA" DataSetColumn="FECHA" />
              <Mapping SourceColumn="IDCAJA" DataSetColumn="IDCAJA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_GASTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdCajasFechas" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdCajasFechas" GeneratorSourceName="FillByIdCajasFechas" GetMethodModifier="Public" GetMethodName="GetDataByIdCajasFechas" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdCajasFechas" UserSourceName="FillByIdCajasFechas">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDDOCUMENTO, NUMERO, IDTIPOGASTO, VALOR, DESCRIPCION, FECHA, IDCAJA
FROM            CAJ_GASTO
WHERE        (FECHA BETWEEN :PDESDEF AND :PHASTAF) AND (IDCAJA = :PIDCAJA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PDESDEF" ColumnName="FECHA" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PDESDEF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PHASTAF" ColumnName="FECHA" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PHASTAF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDCAJA" ColumnName="IDCAJA" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_GASTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocNumero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocNumero" GeneratorSourceName="FillByIdDocNumero" GetMethodModifier="Public" GetMethodName="GetDataByIdDocNumero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocNumero" UserSourceName="FillByIdDocNumero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDDOCUMENTO, NUMERO, IDTIPOGASTO, VALOR, DESCRIPCION, FECHA, IDCAJA
FROM            CAJ_GASTO
WHERE        (IDDOCUMENTO = :PIDDOC) AND (NUMERO = :PNUMERO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOC" ColumnName="IDDOCUMENTO" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_GASTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdTipoDocFechas" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdTipoDocFechas" GeneratorSourceName="FillByIdTipoDocFechas" GetMethodModifier="Public" GetMethodName="GetDataByIdTipoDocFechas" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdTipoDocFechas" UserSourceName="FillByIdTipoDocFechas">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDDOCUMENTO, NUMERO, IDTIPOGASTO, VALOR, DESCRIPCION, FECHA, IDCAJA
FROM            CAJ_GASTO
WHERE        (IDTIPOGASTO = :PIDGASTO) AND  (FECHA BETWEEN :PDESDEF AND :PHASTAF) AND (IDCAJA = :PIDCAJA) </CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDGASTO" ColumnName="IDTIPOGASTO" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDGASTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOGASTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PDESDEF" ColumnName="FECHA" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PDESDEF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PHASTAF" ColumnName="FECHA" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PHASTAF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDCAJA" ColumnName="IDCAJA" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GastoExiste" Modifier="Public" Name="GastoExiste" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GastoExiste">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS NREG
FROM            CAJ_GASTO
WHERE        (IDDOCUMENTO = :PIDDOC) AND (NUMERO = :PNUMERO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOC" ColumnName="IDDOCUMENTO" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetValorGastosByCajaFechas" Modifier="Public" Name="GetValorGastosByCajaFechas" QueryType="Scalar" ScalarCallRetval="System.Decimal, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetValorGastosByCajaFechas">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        SUM(VALOR) AS VRGASTOS
FROM            CAJ_GASTO
WHERE        (IDCAJA = :PIDCAJA) AND (FECHA BETWEEN :PDESDEF AND :PHASTAf)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDCAJA" ColumnName="IDCAJA" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PDESDEF" ColumnName="FECHA" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PDESDEF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PHASTAf" ColumnName="FECHA" DataSourceName="SAMUEL.CAJ_GASTO" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PHASTAf" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAJ_TIPOGASTOTableAdapter" GeneratorDataComponentClassName="CAJ_TIPOGASTOTableAdapter" Name="CAJ_TIPOGASTO" UserDataComponentName="CAJ_TIPOGASTOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_TIPOGASTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CAJ_TIPOGASTO" WHERE (("IDGASTO" = :Original_IDGASTO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDGASTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDGASTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CAJ_TIPOGASTO" ("IDGASTO", "DESCRIPCION") VALUES (:IDGASTO, :DESCRIPCION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDGASTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDGASTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDGASTO, DESCRIPCION FROM SAMUEL.CAJ_TIPOGASTO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CAJ_TIPOGASTO" SET "IDGASTO" = :IDGASTO, "DESCRIPCION" = :DESCRIPCION WHERE (("IDGASTO" = :Original_IDGASTO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDGASTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDGASTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDGASTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDGASTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDGASTO" DataSetColumn="IDGASTO" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_TIPOGASTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByidTipoGasto" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByidTipoGasto" GeneratorSourceName="FillByidTipoGasto" GetMethodModifier="Public" GetMethodName="GetDataByidTipoGasto" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByidTipoGasto" UserSourceName="FillByidTipoGasto">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDGASTO, DESCRIPCION
FROM            CAJ_TIPOGASTO
WHERE        (IDGASTO = :PIDGASTO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDGASTO" ColumnName="IDGASTO" DataSourceName="SAMUEL.CAJ_TIPOGASTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDGASTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDGASTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAJ_CONSIGNATableAdapter" GeneratorDataComponentClassName="CAJ_CONSIGNATableAdapter" Name="CAJ_CONSIGNA" UserDataComponentName="CAJ_CONSIGNATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_CONSIGNA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "CAJ_CONSIGNA" WHERE (("IDCONSIGNA" = :Original_IDCONSIGNA) AND ((:IsNull_FECHA = 1 AND "FECHA" IS NULL) OR ("FECHA" = :Original_FECHA)) AND ((:IsNull_IDBANCO = 1 AND "IDBANCO" IS NULL) OR ("IDBANCO" = :Original_IDBANCO)) AND ((:IsNull_VALORCONSIGNA = 1 AND "VALORCONSIGNA" IS NULL) OR ("VALORCONSIGNA" = :Original_VALORCONSIGNA)) AND ((:IsNull_IDCAJA = 1 AND "IDCAJA" IS NULL) OR ("IDCAJA" = :Original_IDCAJA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDCONSIGNA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDCONSIGNA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDBANCO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDBANCO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBANCO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDBANCO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORCONSIGNA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORCONSIGNA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORCONSIGNA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORCONSIGNA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCAJA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "CAJ_CONSIGNA" ("IDCONSIGNA", "FECHA", "IDBANCO", "VALORCONSIGNA", "IDCAJA") VALUES (:IDCONSIGNA, :FECHA, :IDBANCO, :VALORCONSIGNA, :IDCAJA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDCONSIGNA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDCONSIGNA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBANCO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDBANCO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORCONSIGNA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORCONSIGNA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDCONSIGNA, FECHA, IDBANCO, VALORCONSIGNA, IDCAJA
FROM            CAJ_CONSIGNA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "CAJ_CONSIGNA" SET "IDCONSIGNA" = :IDCONSIGNA, "FECHA" = :FECHA, "IDBANCO" = :IDBANCO, "VALORCONSIGNA" = :VALORCONSIGNA, "IDCAJA" = :IDCAJA WHERE (("IDCONSIGNA" = :Original_IDCONSIGNA) AND ((:IsNull_FECHA = 1 AND "FECHA" IS NULL) OR ("FECHA" = :Original_FECHA)) AND ((:IsNull_IDBANCO = 1 AND "IDBANCO" IS NULL) OR ("IDBANCO" = :Original_IDBANCO)) AND ((:IsNull_VALORCONSIGNA = 1 AND "VALORCONSIGNA" IS NULL) OR ("VALORCONSIGNA" = :Original_VALORCONSIGNA)) AND ((:IsNull_IDCAJA = 1 AND "IDCAJA" IS NULL) OR ("IDCAJA" = :Original_IDCAJA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDCONSIGNA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDCONSIGNA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBANCO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDBANCO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORCONSIGNA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORCONSIGNA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDCONSIGNA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDCONSIGNA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDBANCO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDBANCO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBANCO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDBANCO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORCONSIGNA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORCONSIGNA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORCONSIGNA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORCONSIGNA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCAJA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCONSIGNA" DataSetColumn="IDCONSIGNA" />
              <Mapping SourceColumn="FECHA" DataSetColumn="FECHA" />
              <Mapping SourceColumn="IDBANCO" DataSetColumn="IDBANCO" />
              <Mapping SourceColumn="VALORCONSIGNA" DataSetColumn="VALORCONSIGNA" />
              <Mapping SourceColumn="IDCAJA" DataSetColumn="IDCAJA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_CONSIGNA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdCajaFechas" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdCajaFechas" GeneratorSourceName="FillByIdCajaFechas" GetMethodModifier="Public" GetMethodName="GetDataByIdCajaFechas" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdCajaFechas" UserSourceName="FillByIdCajaFechas">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDCONSIGNA, FECHA, IDBANCO, VALORCONSIGNA, IDCAJA
FROM            CAJ_CONSIGNA
WHERE        (FECHA BETWEEN :PDESDEF AND :PHASTAF) AND (IDCAJA = :PIDCAJA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PDESDEF" ColumnName="FECHA" DataSourceName="SAMUEL.CAJ_CONSIGNA" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PDESDEF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PHASTAF" ColumnName="FECHA" DataSourceName="SAMUEL.CAJ_CONSIGNA" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PHASTAF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDCAJA" ColumnName="IDCAJA" DataSourceName="SAMUEL.CAJ_CONSIGNA" DataTypeServer="NVARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDCAJA" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAJ_CONSIGNA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdConsigna" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdConsigna" GeneratorSourceName="FillByIdConsigna" GetMethodModifier="Public" GetMethodName="GetDataByIdConsigna" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdConsigna" UserSourceName="FillByIdConsigna">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT FECHA, IDBANCO, IDCAJA, IDCONSIGNA, VALORCONSIGNA FROM CAJ_CONSIGNA WHERE (IDCONSIGNA = :PIDCONSIGNA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDCONSIGNA" ColumnName="IDCONSIGNA" DataSourceName="SAMUEL.CAJ_CONSIGNA" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PIDCONSIGNA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDCONSIGNA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetConsec" Modifier="Public" Name="GetConsec" QueryType="Scalar" ScalarCallRetval="System.Decimal, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetConsec">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        NVL(MAX(IDCONSIGNA),0) + 1 AS CONSEC
FROM            CAJ_CONSIGNA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetValorConsignaIdCajaFechas" Modifier="Public" Name="GetValorConsignaIdCajaFechas" QueryType="Scalar" ScalarCallRetval="System.Decimal, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetValorConsignaIdCajaFechas">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        SUM(VALORCONSIGNA) AS TOTALCONSIGNA
FROM            CAJ_CONSIGNA
WHERE        (FECHA BETWEEN :PDESDEF AND :PHASTAF) AND (IDCAJA = :PIDCAJA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PDESDEF" ColumnName="FECHA" DataSourceName="SAMUEL.CAJ_CONSIGNA" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PDESDEF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PHASTAF" ColumnName="FECHA" DataSourceName="SAMUEL.CAJ_CONSIGNA" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PHASTAF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDCAJA" ColumnName="IDCAJA" DataSourceName="SAMUEL.CAJ_CONSIGNA" DataTypeServer="NVARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDCAJA" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsCaja" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsCaja" msprop:Generator_DataSetName="dsCaja" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="CAJ_CAJAS" msprop:Generator_UserTableName="CAJ_CAJAS" msprop:Generator_RowDeletedName="CAJ_CAJASRowDeleted" msprop:Generator_RowChangedName="CAJ_CAJASRowChanged" msprop:Generator_RowClassName="CAJ_CAJASRow" msprop:Generator_RowChangingName="CAJ_CAJASRowChanging" msprop:Generator_RowEvArgName="CAJ_CAJASRowChangeEvent" msprop:Generator_RowEvHandlerName="CAJ_CAJASRowChangeEventHandler" msprop:Generator_TableClassName="CAJ_CAJASDataTable" msprop:Generator_TableVarName="tableCAJ_CAJAS" msprop:Generator_RowDeletingName="CAJ_CAJASRowDeleting" msprop:Generator_TablePropName="CAJ_CAJAS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCAJA" msprop:Generator_UserColumnName="IDCAJA" msprop:Generator_ColumnPropNameInRow="IDCAJA" msprop:Generator_ColumnVarNameInTable="columnIDCAJA" msprop:Generator_ColumnPropNameInTable="IDCAJAColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDSUCURSAL" msprop:Generator_UserColumnName="IDSUCURSAL" msprop:Generator_ColumnPropNameInRow="IDSUCURSAL" msprop:Generator_ColumnVarNameInTable="columnIDSUCURSAL" msprop:Generator_ColumnPropNameInTable="IDSUCURSALColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FECHAULTCUADRE" msprop:Generator_UserColumnName="FECHAULTCUADRE" msprop:Generator_ColumnPropNameInRow="FECHAULTCUADRE" msprop:Generator_ColumnVarNameInTable="columnFECHAULTCUADRE" msprop:Generator_ColumnPropNameInTable="FECHAULTCUADREColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="SALDO" msprop:Generator_UserColumnName="SALDO" msprop:Generator_ColumnPropNameInRow="SALDO" msprop:Generator_ColumnVarNameInTable="columnSALDO" msprop:Generator_ColumnPropNameInTable="SALDOColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAJ_GASTO" msprop:Generator_UserTableName="CAJ_GASTO" msprop:Generator_RowDeletedName="CAJ_GASTORowDeleted" msprop:Generator_RowChangedName="CAJ_GASTORowChanged" msprop:Generator_RowClassName="CAJ_GASTORow" msprop:Generator_RowChangingName="CAJ_GASTORowChanging" msprop:Generator_RowEvArgName="CAJ_GASTORowChangeEvent" msprop:Generator_RowEvHandlerName="CAJ_GASTORowChangeEventHandler" msprop:Generator_TableClassName="CAJ_GASTODataTable" msprop:Generator_TableVarName="tableCAJ_GASTO" msprop:Generator_RowDeletingName="CAJ_GASTORowDeleting" msprop:Generator_TablePropName="CAJ_GASTO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="IDTIPOGASTO" msprop:Generator_UserColumnName="IDTIPOGASTO" msprop:Generator_ColumnPropNameInRow="IDTIPOGASTO" msprop:Generator_ColumnVarNameInTable="columnIDTIPOGASTO" msprop:Generator_ColumnPropNameInTable="IDTIPOGASTOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VALOR" msprop:Generator_UserColumnName="VALOR" msprop:Generator_ColumnPropNameInRow="VALOR" msprop:Generator_ColumnVarNameInTable="columnVALOR" msprop:Generator_ColumnPropNameInTable="VALORColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FECHA" msprop:Generator_UserColumnName="FECHA" msprop:Generator_ColumnPropNameInRow="FECHA" msprop:Generator_ColumnVarNameInTable="columnFECHA" msprop:Generator_ColumnPropNameInTable="FECHAColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IDCAJA" msprop:Generator_UserColumnName="IDCAJA" msprop:Generator_ColumnPropNameInRow="IDCAJA" msprop:Generator_ColumnVarNameInTable="columnIDCAJA" msprop:Generator_ColumnPropNameInTable="IDCAJAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAJ_TIPOGASTO" msprop:Generator_UserTableName="CAJ_TIPOGASTO" msprop:Generator_RowDeletedName="CAJ_TIPOGASTORowDeleted" msprop:Generator_RowChangedName="CAJ_TIPOGASTORowChanged" msprop:Generator_RowClassName="CAJ_TIPOGASTORow" msprop:Generator_RowChangingName="CAJ_TIPOGASTORowChanging" msprop:Generator_RowEvArgName="CAJ_TIPOGASTORowChangeEvent" msprop:Generator_RowEvHandlerName="CAJ_TIPOGASTORowChangeEventHandler" msprop:Generator_TableClassName="CAJ_TIPOGASTODataTable" msprop:Generator_TableVarName="tableCAJ_TIPOGASTO" msprop:Generator_RowDeletingName="CAJ_TIPOGASTORowDeleting" msprop:Generator_TablePropName="CAJ_TIPOGASTO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDGASTO" msprop:Generator_UserColumnName="IDGASTO" msprop:Generator_ColumnPropNameInRow="IDGASTO" msprop:Generator_ColumnVarNameInTable="columnIDGASTO" msprop:Generator_ColumnPropNameInTable="IDGASTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAJ_CONSIGNA" msprop:Generator_UserTableName="CAJ_CONSIGNA" msprop:Generator_RowDeletedName="CAJ_CONSIGNARowDeleted" msprop:Generator_RowChangedName="CAJ_CONSIGNARowChanged" msprop:Generator_RowClassName="CAJ_CONSIGNARow" msprop:Generator_RowChangingName="CAJ_CONSIGNARowChanging" msprop:Generator_RowEvArgName="CAJ_CONSIGNARowChangeEvent" msprop:Generator_RowEvHandlerName="CAJ_CONSIGNARowChangeEventHandler" msprop:Generator_TableClassName="CAJ_CONSIGNADataTable" msprop:Generator_TableVarName="tableCAJ_CONSIGNA" msprop:Generator_RowDeletingName="CAJ_CONSIGNARowDeleting" msprop:Generator_TablePropName="CAJ_CONSIGNA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCONSIGNA" msprop:Generator_UserColumnName="IDCONSIGNA" msprop:Generator_ColumnVarNameInTable="columnIDCONSIGNA" msprop:Generator_ColumnPropNameInRow="IDCONSIGNA" msprop:Generator_ColumnPropNameInTable="IDCONSIGNAColumn" type="xs:decimal" />
              <xs:element name="FECHA" msprop:Generator_UserColumnName="FECHA" msprop:Generator_ColumnVarNameInTable="columnFECHA" msprop:Generator_ColumnPropNameInRow="FECHA" msprop:Generator_ColumnPropNameInTable="FECHAColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IDBANCO" msprop:Generator_UserColumnName="IDBANCO" msprop:Generator_ColumnVarNameInTable="columnIDBANCO" msprop:Generator_ColumnPropNameInRow="IDBANCO" msprop:Generator_ColumnPropNameInTable="IDBANCOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VALORCONSIGNA" msprop:Generator_UserColumnName="VALORCONSIGNA" msprop:Generator_ColumnVarNameInTable="columnVALORCONSIGNA" msprop:Generator_ColumnPropNameInRow="VALORCONSIGNA" msprop:Generator_ColumnPropNameInTable="VALORCONSIGNAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDCAJA" msprop:Generator_UserColumnName="IDCAJA" msprop:Generator_ColumnVarNameInTable="columnIDCAJA" msprop:Generator_ColumnPropNameInRow="IDCAJA" msprop:Generator_ColumnPropNameInTable="IDCAJAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAJ_CAJAS" />
      <xs:field xpath="mstns:IDCAJA" />
    </xs:unique>
    <xs:unique name="CAJ_GASTO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAJ_GASTO" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
    </xs:unique>
    <xs:unique name="CAJ_TIPOGASTO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAJ_TIPOGASTO" />
      <xs:field xpath="mstns:IDGASTO" />
    </xs:unique>
    <xs:unique name="CAJ_CONSIGNA_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAJ_CONSIGNA" />
      <xs:field xpath="mstns:IDCONSIGNA" />
    </xs:unique>
  </xs:element>
</xs:schema>